How to Create a View in MySQL

Any view has an associated select to obtain the view data, in order to create a view you need to use a SQL statement defining the view name and the view select:

create view employees_making_more_than_100k as
    select emp_id, first_name, last_name from employee
    where salary > 100000.00;

IN THIS PAGE